Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · 📊
Reference for MySqlSlowLogs table in Azure Monitor Logs.
| Attribute | Value |
|---|---|
| Category | Audit, Azure Resources |
| Basic Logs Eligible | ✓ Yes (source) |
| Supports Transformations | ✓ Yes (source) |
| Ingestion API Supported | ✗ No |
| Azure Monitor Tables Reference | View Documentation |
Source: Azure Monitor documentation
| Column Name | Type | Description |
|---|---|---|
| _BilledSize | real | The record size in bytes |
| _IsBillable | string | Specifies whether ingesting the data is billable. When _IsBillable isfalseingestion isn't billed to your Azure account |
| _ResourceId | string | A unique identifier for the resource that the record is associated with |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| Category | string | Category of log. |
| Db | string | Name of database accessed. |
| EventClass | string | Class of the log event. |
| Host | string | Host name of client connecting to MySQL. |
| InsertId | int | The insert ID. |
| LastInsertId | int | The first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most recently executed INSERT statement. |
| LockDurationMs | long | Total time in milliseconds the query was locked. |
| QueryDurationMs | long | Total time in milliseconds the query took to execute. |
| ReplicationSetRole | string | Replication set role of MySQL flexible server. |
| RowsExamined | int | Number of rows examined. |
| RowsSent | int | Number of rows sent. |
| ServerId | int | ID of the MySQL flexible server. |
| SourceSystem | string | The type of agent the event was collected by. For example,OpsManagerfor Windows agent, either direct connect or Operations Manager,Linuxfor all Linux agents, orAzurefor Azure Diagnostics |
| SqlText | string | Full query text. |
| StartTime | datetime | Query start time in UTC timestamp. |
| TenantId | string | The Log Analytics workspace ID |
| ThreadId | int | ID of thread that executed the query. |
| TimeGenerated | datetime | The timestamp (UTC) of when the log was generated. |
| Type | string | The name of the table |
This table collects data from the following Azure resource types:
microsoft.dbformysql/flexibleserversBrowse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · 📊